package queryTree;
/**
 * @author Van
 */
import example.util;
import optimization.SQLParsingException;

public class TestMain {
	public static void main(String[] args) {
		// TODO code application logic here
		//SELECT supplies.ITEM,PRICE, menu FROM SUPPLIES,recipe  WHERE item = ingredient and price = 3
		String sql = "SELECT supplies.ITEM,PRICE, menu FROM SUPPLIES,recipe  " +
            		"WHERE item = ingredient  and price = 3";
		String sql1 = "select supplies.ITEM from supplies where item = '3' and price = 3";
		Main m = new Main(); 
		try {
			JoinNode t = (JoinNode) Main.getTreeFromSQL(sql);
			util u = new util();
//			u.buildMessage(t, "supplies");
			
			
			System.out.println("hh");
		} catch (SQLParsingException e) {
			e.printStackTrace();
		}
	
	}
}
